package com.ruanyuan.springboot.dao;

import com.ruanyuan.springboot.pojo.Address;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 地址表数据访问层
 */
public interface AddressDao {
    /**
     * 查询全部地址信息
     */
    @Select("SELECT * FROM address")
    public List<Address> seleteAddress();

    /**
     * 通过id查询地址
     * @return
     */
    @Select("SELECT * FROM address where addid=#{id}")
    public Address seleteAddressid(String id);
}
